Indexing for High Performance
High Performance MySQL #MySQL
Indexing Basics
Types of Indexes
Benefits of Indexes
Indexing Strategies for High Performance
Prefix Indexes and Index Selectivity
Multicolumn Indexes
Choosing a Good Column Order
Clustered Indexes
Covering Indexes
Using Index Scans for Sorts
Redundant and Duplicate Indexes
Unused Indexes
Index and Table Maintenance
Finding and Repairing Table Corruption
Updating Index Statistics
Reducing Index and Data Fragmentation
Summary